{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Connection Charges","Existing Meter Flow Credit","NonRes_ConnCharges_Given_ADF","DropDownDef"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":27,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Connection Charges","index":0,"n_rows":143,"n_cols":15,"rows_kept":143,"cut":false,"hidden":false,"merged":[[37,1,37,5],[42,1,42,5]]}
[]
[null,"Water and Wastewater Connection Fee Calculator Tool"]
[]
[null,"Where is the property?"]
[null,null,null,"City",null,null,null,null,{"$f":"IF(H5=\"Single Family\",\"*** IIA Fees Not Applicable for Single Family Connections***\",\"\")","v":""}]
[null,null,null,"County"]
[null,null,null,"County but no-surcharge*"]
[null,null,"*Federal, Florida, other government entities (e.g. County, GRU) and places of religious assembly are exempt from the surcharge tax"]
[]
[null,"What type of connection?"]
[null,null,null,"Single Family",{"$f":"IF(C11=\"X\",\"Existing well?\",\"\")","v":""}]
[null,null,null,"Multi-family",{"$f":"IF(C12=\"X\",\"Number of bedrooms\",\"\")","v":""}]
[null,null,null,"Nonresidential",{"$f":"IF(C13=\"X\",\"Facility Type\",\"\")","v":""},null,{"$f":"IF(C13=\"X\",\"Building Square Footage\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(H13=\"\",\"\",\"Estimated annual average daily flow (gpd)\")","v":""},{"$f":"IFERROR(VLOOKUP(F13,$C$109:$H$143,6,FALSE)*H13,\"\")","v":""}]
[]
[null,"What type of service?"]
[null,null,null,"Water",{"$f":"IF(C17=\"X\",\"Meter Size\",\"\")","v":""},null,{"$f":"IF(C17=\"X\",\"Meter Install Type\",\"\")","v":""},null,{"$f":"IF(F17=\"\",\"\",IF(F17=\"1 - in\",\"\",IF(F17=\"3/4 - in\",\"\",\"(GRU installs meters greater than 1-in: Meter, box & yoke)\")))","v":""}]
[null,null,null,null,{"$f":"IF(C17=\"X\",\"Number of Meters\",\"\")","v":""},null,{"$f":"IF(F17=\"\",\"\",IF(F17=\"1 - in\",\"\",IF(F17=\"3/4 - in\",\"\",\"*** Send meter requests greater than 1-in to W/WW Engineering for review ***\")))","v":""}]
[null,null,null,"Wastewater"]
[null,null,null,"Irrigation",{"$f":"IF(C20=\"X\",\"Meter Size\",\"\")","v":""},null,{"$f":"IF(C20=\"X\",\"Meter Install Type\",\"\")","v":""},null,{"$f":"IF(F20=\"\",\"\",IF(F20=\"1 - in\",\"\",IF(F20=\"3/4 - in\",\"\",\"(GRU installs meters greater than 1-in: Meter, box & yoke)\")))","v":""}]
[null,null,null,null,{"$f":"IF(C20=\"X\",\"Number of Meters\",\"\")","v":""}]
[null,null,null,"Hydrant meter"]
[null,null,null,"Temporary water"]
[null,null,null,"Reclaimed water",null,null,null,null,null,null,null,null,"                                                   bvvv                                                                                                             ",null,""]
[]
[null,"Developer fees"]
[null,null,"Plan review fee"]
[null,null,"Inspection fee",null,"Linear feet water",null,"Linear feet wastewater"]
[null,null,"Tap size ( ≥  1\")"]
[]
[null,"Connection Fees"]
[null,"Water capacity connection:",null,null,{"$f":"\"T&D   $\"&ROUND(IF(C17=\"X\",IF($C$11=\"X\",$D$53,IF($C$12=\"X\",$F$12*70*1.547,IF($C$13=\"X\",IF($H$14<=280,$D$53,$H$14*1.547),0))),0),2)&\" +\"","v":"T&D   $0 +"},{"$f":"\"WTP   $\"&ROUND(IF(C17=\"X\",IF($C$11=\"X\",$E$53,IF($C$12=\"X\",$F$12*70*2.306,IF($C$13=\"X\",IF($H$14<=280,$E$53,$H$14*2.306),0))),0),2)&\"  =\"","v":"WTP   $0  ="},{"$f":"IF(C17=\"X\",IF($C$11=\"X\",$F$53,IF($C$12=\"X\",$F$12*70*F56,IF($C$13=\"X\",IF($H$14<=280,$F$53,$H$14*F56),0))),0)","v":0}]
[null,"Water meter equipment and install",null,null,null,null,{"$f":"(IF(H17=\"Meter only\",VLOOKUP(F17,C60:D61,2,FALSE),IF(H17=\"Meter, box, & yoke\",VLOOKUP(F17,C60:E70,3,FALSE),0))+IF(C17=\"X\",IF(F11=\"X\",F60,0),0))*F18","v":0},{"$f":"IF(F11=\"X\",IF(C17=\"X\",\"  GRU installed backflow preventer fee included:  $200\",\"\"),\"\")","v":""}]
[null,"Wastewater capacity connection:",null,null,{"$f":"\"Collection System   $\"&ROUND(IF(C19=\"X\",IF($C$11=\"X\",$D$82,IF($C$12=\"X\",$F$12*70*2.567,IF($C$13=\"X\",IF($H$14<=280,$D$82,$H$14*2.567),0))),0),2)&\" +\"","v":"Collection System   $0 +"},{"$f":"\"WWTP   $\"&ROUND(IF(C19=\"X\",IF($C$11=\"X\",$E$82,IF($C$12=\"X\",$F$12*70*11.478,IF($C$13=\"X\",IF($H$14<=280,$E$82,$H$14*11.478),0))),0),2)&\"  =\"","v":"WWTP   $0  ="},{"$f":"IF(C19=\"X\",IF($C$11=\"X\",$F$82,IF($C$12=\"X\",$F$12*70*F85,IF($C$13=\"X\",IF($H$14<=280,$F$82,$H$14*F85),0))),0)","v":0}]
[null,"Irrigation meter equipment and install",null,null,null,null,{"$f":"(IF(H20=\"Meter only\",VLOOKUP(F20,C60:D61,2,FALSE),IF(H20=\"Meter, box, & yoke\",VLOOKUP(F20,C60:E70,3,FALSE),0)))*F21","v":0}]
[null,"Hydrant meter",null,null,null,null,{"$f":"IF(C22=\"X\",E75+E76,0)","v":0}]
[null,"Reclaimed water",null,null,null,null,0]
[null,"Subtotal",null,null,null,null,{"$f":"SUM(G32:G37)","v":0}]
[null,"Developer Fees"]
[null,"Plan review fee",null,null,null,null,{"$f":"IF(D27=\"water\",D90,IF(D27=\"wastewater\",D91,IF(D27=\"water, wastewater\",D90+D91,0)))","v":0}]
[null,"Inspection fee",null,null,null,null,{"$f":"F28*D94+H28*D95","v":0}]
[null,"Tapping fee",null,null,null,null,{"$f":"IFERROR(VLOOKUP(D29,$C$99:$D$104,2,FALSE),0)","v":0}]
[]
[null,"Surcharge  (25-percent)",null,null,null,null,{"$f":"IF(C6=\"x\",(G38+G43)*0.25,0)","v":0}]
[null,"Total ",null,null,null,null,{"$f":"G44+G43+G38","v":0}]
[]
["FEE DETAILS"]
[]
[null,"GRU WATER/WASTEWATER FEES FY 2026 (Effective October 1, 2025)"]
[null,"WATER "]
[null,null,"CAPACITY CHARGE"]
[null,null,"Consumption","Transmission and Distribution Connection Charge","Water Treatment Plant Connection Charge","Total Water Connection Charge"]
[null,null,"Single Family & Small Nonresidential                             ≤ 280 gpd",578,870,{"$f":"ROUND(D53,0)+ROUND(E53,0)","v":1448}]
[null,null,"Single family, heated & cooled area > 850 ft2 but < 1,400 ft2",{"$f":"D53*0.65","v":375.7},{"$f":"E53*0.65","v":565.5},{"$f":"ROUND(D54,0)+ROUND(E54,0)","v":942}]
[null,null,"Single family, heated & cooled area < 850 ft2",{"$f":"D53*100/280","v":206.42857142857142},{"$f":"E53*100/280","v":310.71428571428572},{"$f":"ROUND(D55,0)+ROUND(E55,0)","v":517}]
[null,null,"Nonresidential                                                             ˃ 280 gpd ($/gpd) ",2.06,3.11,{"$f":"D56+E56","v":5.17}]
[]
[null,null,"EQUIPMENT CHARGE"]
[null,null,"Meter size (in)","Meter Charge  - Developer Install Box & Yoke*            ","Meter Charge -                GRU Install Box & Yoke","GRU Installed Backflow Preventer"]
[null,null,"3/4 - in",530,872,408]
[null,null,"1 - in",658,1140]
[null,null,"1 1/2\"",2022,2883]
[null,null,"2\"",2302,3080]
[null,null,"3\"",null,17606]
[null,null,"4\"",null,19569]
[null,null,"4\" UL Rated Fire Line Mtr",null,24199]
[null,null,"6\"",null,25792]
[null,null,"6\" UL Rated Fire Line Mtr",null,30028]
[null,null,"8\"",null,30397]
[null,null,"4\" UL Rated Fire Line Mtr",null,36221]
[null,null,"*Existing meter box or developer installed meter box."]
[]
[null,null,"HYDRANT METER SERVICE"]
[null,null,"Description",null,"Fee"]
[null,null,"Nonrefundable install & removal",null,127]
[null,null,"Hydrant Meter Deposit",null,1548]
[]
[]
[null,"WASTEWATER "]
[]
[null,null,"Consumption","Wastewater Collection System Connection Charge","Wastewater Treatment Plant Connection Charge","Total Wastewater Connection Charge"]
[null,null,"Single Family & Small Nonresidential                             ≤ 280 gpd)",961,3293,{"$f":"ROUND(D82,0)+ROUND(E82,0)","v":4254}]
[null,null,"Single family, heated & cooled area > 850 ft2 but < 1,400 ft2",{"$f":"D82*0.65","v":624.65},{"$f":"E82*0.65","v":2140.4500000000003},{"$f":"ROUND(D83,0)+ROUND(E83,0)","v":2765}]
[null,null,"Single family, heated & cooled area < 850 ft2",{"$f":"D82*100/280","v":343.21428571428572},{"$f":"E82*100/280","v":1176.0714285714287},{"$f":"ROUND(D84,0)+ROUND(E84,0)","v":1519}]
[null,null,"Nonresidential                                                             ˃ 280 gpd ($/gpd) ",3.43,11.76,{"$f":"E85+D85","v":15.19}]
[]
[null,"DEVELOPER FEES"]
[]
[null,null,"PLAN REVIEW FEES",null,null,"I-DISTRICT INFRASTRUCTURE IMPROVEMENT AREA FEES"]
[null,null,"Water",980,null,null,null,"Water","WW","Unit"]
[null,null,"Wastewater",1760,null,"Commercial & Institutional",null,1.3,1.32,"/ft2 gross building area"]
[null,null,null,null,null,"Hotel &/or Motel",null,518.64,527.27,"per room"]
[null,null,"INSPECTION FEES",null,null,"Laboratory (wet)",null,1.56,1.59,"/ft2 gross building area"]
[null,null,"Water",3.17,"per linear foot","Multi-Family Residential",null,363.05,369.09,"per bedroom"]
[null,null,"Wastewater",7.81,"per linear foot","Office & Laboratory (dry)",null,0.77,0.79,"/ft2 gross building area"]
[null,null,null,null,null,"Parking Garage",null,0.77,"NA","/ft2 gross building area"]
[null,null,"TAPPING FEES"]
[null,null,"Tap size (inches)","Charge"]
[null,null,"1\"",1345]
[null,null,"2\"",2038]
[null,null,"4\"",4850]
[null,null,"6\"",5024]
[null,null,"8\"",6246]
[null,null,"12\"",8580]
[]
[null,"NON-RESIDENTIAL FLOW ESTIMATES"]
[]
[null,null,"Category",null,null,null,null,"Coefficient","*  Bldg SQFT  =   GPD"]
[null,null,"Auto: sales, repair, rental, tire, storage, body shops",null,null,null,null,3.0766083811176924E-2]
[null,null,"Car wash",null,null,null,null,1.0615332337770451]
[null,null,"Churches",null,null,null,null,3.326168153081846E-2]
[null,null,"Department Store, Box Store",null,null,null,null,1.0911272384037392E-2]
[null,null,"Drive-in restaurants",null,null,null,null,0.36916606313889844]
[null,null,"Dry cleaning,  laundry mats",null,null,null,null,0.65427027428344198]
[null,null,"Financial Institutions",null,null,null,null,1.8440851898706631E-2]
[null,null,"Fire Station",null,null,null,null,9.8999953277344205E-2]
[null,null,"Florists, greenhouses",null,null,null,null,4.1614963227505221E-2]
[null,null,"Golf courses, driving ranges",null,null,null,null,0.18530352001843775]
[null,null,"Gym, Workout Facility",null,null,null,null,4.1717440714168351E-2]
[null,null,"Hotel",null,null,null,null,0.13492744540979371]
[null,null,"Industrial, manufacturing",null,null,null,null,2.0602493074792245E-2]
[null,null,"Libraries and museums",null,null,null,null,2.1534500000000002E-2]
[null,null,"Lumberyards, sawmills, planning mills",null,null,null,null,1.0339794015083935E-2]
[null,null,"Medical",null,null,null,null,6.0206219348241927E-2]
[null,null,"Mixed Use:  Store & Office, Store & Residential",null,null,null,null,3.4366904840127818E-2]
[null,null,"Mortuaries, cemeteries, crematoriums",null,null,null,null,7.3072943038508864E-2]
[null,null,"Nightclubs, cocktail lounges, bars",null,null,null,null,0.15823727399994045]
[null,null,"Office building",null,null,null,null,3.5478477905406286E-2]
[null,null,"Open storage, building supplies, junk yards, auto wrecking, fuel storage",null,null,null,null,5.5391329223623914E-2]
[null,null,"Pharmacy",null,null,null,null,1.757988482311779E-2]
[null,null,"Private schools, colleges and daycare facilities",null,null,null,null,7.4946551947176754E-2]
[null,null,"Repair service shops (non-automotive)",null,null,null,null,2.5454848575945811E-2]
[null,null,"Restaurants (other than drive-in)",null,null,null,null,0.33430892667911388]
[null,null,"Retirement homes, orphanages, group homes",null,null,null,null,0.10716814586535132]
[null,null,"Service stations",null,null,null,null,7.2371455819145059E-2]
[null,null,"Storage Units",null,null,null,null,1.7938275910055592E-3]
[null,null,"Store, community shopping center (other than supermarkets and department stores)",null,null,null,null,3.4902513496910245E-2]
[null,null,"Supermarkets",null,null,null,null,5.7305595081983719E-2]
[null,null,"Theaters, Bowling alleys, skating rinks, pool halls, enclosed arenas, auditoriums",null,null,null,null,4.6487358202944667E-2]
[null,null,"Union halls, lodges, clubs, club houses ",null,null,null,null,4.4764727016631062E-2]
[null,null,"Utility - other than GRU",null,null,null,null,1.4058744872950776E-2]
[null,null,"Warehouse, distribution centers, truck terminals",null,null,null,null,2.1186440677966101E-2]
[null,null,"Wholesale & manufacturing outlets, produce houses",null,null,null,null,1.5211701064757036E-2]

{"sheet":"Existing Meter Flow Credit","index":1,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
["Flow Credit for Existing Meter(s)"]
[]
[]
[null,null,"Enter Quantity of Meters for Each Meter Size"]
[]
[]
[]
[null,"Meter Size","Number of Meters","Est. Flow","Total Flow Credit"]
[null,"in",null,"ADF GPD","ADF GPD"]
[null,"5/8-in",null,278,{"$f":"C11*D11","v":0}]
[null,"3/4-in",null,809,{"$f":"C12*D12","v":0}]
[null,"1-in",null,927,{"$f":"C13*D13","v":0}]
[null,"1 1/2-in",null,2103,{"$f":"C14*D14","v":0}]
[null,"2-in",null,4253,{"$f":"C15*D15","v":0}]
[null,null,null,"Total Flow Credit:",null,"gpd "]

{"sheet":"NonRes_ConnCharges_Given_ADF","index":2,"n_rows":136,"n_cols":15,"rows_kept":136,"cut":false,"hidden":false,"merged":[[38,1,38,5],[43,1,43,5]]}
[]
[null,"Water and Wastewater Connection Fee Calculator Tool"]
[]
[null,"Where is the property?"]
[null,null,null,"City",null,null,null,null,{"$f":"IF(H5=\"Single Family\",\"*** IIA Fees Not Applicable for Single Family Connections***\",\"\")","v":""}]
[null,null,"X","County"]
[null,null,null,"County but no-surcharge*"]
[null,null,"*Federal, Florida, other government entities (e.g. County, GRU) and places of religious assembly are exempt from the surcharge tax"]
[]
[null,"What type of connection?"]
[null,null,null,"Single Family",{"$f":"IF(C11=\"X\",\"Existing well?\",\"\")","v":""}]
[null,null,null,"Multi-family",{"$f":"IF(C12=\"X\",\"Number of bedrooms\",\"\")","v":""}]
[null,null,"X","Nonresidential",{"$f":"IF(C13=\"X\",\"Facility Type\",\"\")","v":"Facility Type"},null,{"$f":"IF(C13=\"X\",\"Building Square Footage\",\"\")","v":"Building Square Footage"}]
[null,null,null,null,null,null,"Enter Given ADF  ---->",5000,"gpd"]
[]
[null,"What type of service?"]
[null,null,"X","Water",{"$f":"IF(C17=\"X\",\"Meter Size\",\"\")","v":"Meter Size"},"3/4 - in",{"$f":"IF(C17=\"X\",\"Meter Install Type\",\"\")","v":"Meter Install Type"},"Meter only",{"$f":"IF(F17=\"\",\"\",IF(F17=\"1 - in\",\"\",IF(F17=\"3/4 - in\",\"\",\"(GRU installs meters greater than 1-in: Meter, box & yoke)\")))","v":""}]
[null,null,null,null,{"$f":"IF(C17=\"X\",\"Number of Meters\",\"\")","v":"Number of Meters"},1,{"$f":"IF(F17=\"\",\"\",IF(F17=\"1 - in\",\"\",IF(F17=\"3/4 - in\",\"\",\"*** Send meter requests greater than 1-in to W/WW Engineering for review ***\")))","v":""}]
[null,null,"X","Wastewater"]
[null,null,null,"Irrigation",{"$f":"IF(C20=\"X\",\"Meter Size\",\"\")","v":""},null,{"$f":"IF(C20=\"X\",\"Meter Install Type\",\"\")","v":""},null,{"$f":"IF(F20=\"\",\"\",IF(F20=\"1 - in\",\"\",IF(F20=\"3/4 - in\",\"\",\"(GRU installs meters greater than 1-in: Meter, box & yoke)\")))","v":""}]
[null,null,null,null,{"$f":"IF(C20=\"X\",\"Number of Meters\",\"\")","v":""}]
[null,null,null,"Hydrant meter"]
[null,null,null,"Temporary water"]
[null,null,null,"Reclaimed water",null,null,null,null,null,null,null,null,"                                                   bvvv                                                                                                             ",null,""]
[]
[null,"Developer fees"]
[null,null,"Plan review fee"]
[null,null,"Inspection fee",null,"Linear feet water",null,"Linear feet wastewater"]
[null,null,"Tap size ( ≥  1 ½\")"]
[]
[null,"Connection Fees"]
[null,"Water capacity connection:",null,null,{"$f":"\"T&D   $\"&ROUND(IF(C17=\"X\",IF($C$11=\"X\",$D$54,IF($C$12=\"X\",$F$12*70*$D$55,IF($C$13=\"X\",IF($H$14<=280,$D$54,$H$14*$D$55),0))),0),2)&\" +\"","v":"T&D   $10300 +"},{"$f":"\"WTP   $\"&ROUND(IF(C17=\"X\",IF($C$11=\"X\",$E$54,IF($C$12=\"X\",$F$12*70*$E$55,IF($C$13=\"X\",IF($H$14<=280,$E$54,$H$14*$E$55),0))),0),2)&\"  =\"","v":"WTP   $15550  ="},{"$f":"IF(C17=\"X\",IF($C$11=\"X\",$F$54,IF($C$12=\"X\",$F$12*70*$F$55,IF($C$13=\"X\",IF($H$14<=280,$F$54,$H$14*$F$55),0))),0)","v":25850}]
[null,"Water meter equipment and install",null,null,null,null,{"$f":"(IF(H17=\"Meter only\",VLOOKUP(F17,C59:D60,2,FALSE),IF(H17=\"Meter, box, & yoke\",VLOOKUP(F17,C59:E66,3,FALSE),0))+IF(C17=\"X\",IF(F11=\"X\",F59,0),0))*F18","v":530},{"$f":"IF(F11=\"X\",IF(C17=\"X\",\"  GRU installed backflow preventer fee included:  $200\",\"\"),\"\")","v":""}]
[null,"Wastewater capacity connection:",null,null,{"$f":"\"Collection System   $\"&ROUND(IF(C19=\"X\",IF($C$11=\"X\",$D$79,IF($C$12=\"X\",$F$12*70*$D$80,IF($C$13=\"X\",IF($H$14<=280,$D$79,$H$14*$D$80),0))),0),2)&\" +\"","v":"Collection System   $17150 +"},{"$f":"\"WWTP   $\"&ROUND(IF(C19=\"X\",IF($C$11=\"X\",$E$79,IF($C$12=\"X\",$F$12*70*$E$80,IF($C$13=\"X\",IF($H$14<=280,$E$79,$H$14*$E$80),0))),0),2)&\"  =\"","v":"WWTP   $58800  ="},{"$f":"IF(C19=\"X\",IF($C$11=\"X\",$F$79,IF($C$12=\"X\",$F$12*70*$F$80,IF($C$13=\"X\",IF($H$14<=280,$F$79,$H$14*$F$80),0))),0)","v":75950}]
[null,"Irrigation meter equipment and install",null,null,null,null,{"$f":"(IF(H20=\"Meter only\",VLOOKUP(F20,C59:D60,2,FALSE),IF(H20=\"Meter, box, & yoke\",VLOOKUP(F20,C59:E66,3,FALSE),0)))*F21","v":0}]
[null,"Hydrant meter",null,null,null,null,{"$f":"IF(C22=\"X\",E71+E72,0)","v":0},{"$f":"IF(G36>0,\"Nonrefundable installation & removalal fee $95; Deposit $1,160\",\"\")","v":""}]
[null,"Temporary water meter",null,null,null,null,{"$f":"IF(C23=\"X\",E71+E73,0)","v":0},{"$f":"IF(G37>0,\"Nonrefundable installation & removalal fee $95; Deposit $1,130\",\"\")","v":""}]
[null,"Reclaimed water",null,null,null,null,0]
[null,"Subtotal",null,null,null,null,{"$f":"SUM(G32:G38)","v":102330}]
[null,"Developer Fees"]
[null,"Plan review fee"]
[null,"Inspection fee",null,null,null,null,{"$f":"F28*D89+H28*D90","v":0}]
[null,"Tapping fee"]
[]
[null,"Surcharge  (25-percent)",null,null,null,null,{"$f":"IF(C6=\"x\",(G39+G44)*0.25,0)","v":25582.5}]
[null,"Total ",null,null,null,null,{"$f":"G45+G44+G39","v":127912.5}]
[]
["FEE DETAILS"]
[]
[null,"WATER "]
[]
[null,null,"CAPACITY CHARGE"]
[null,null,"Consumption","Transmission and Distribution Connection Charge","Water Treatment Plant Connection Charge","Total Water Connection Charge"]
[null,null,"Single Family & Small Nonresidential                             ≤ 280 gpd",{"$f":"'Connection Charges'!D53","v":578},{"$f":"'Connection Charges'!E53","v":870},{"$f":"E54+D54","v":1448}]
[null,null,"Nonresidential                                                             ˃ 280 gpd ($/gpd)",{"$f":"'Connection Charges'!D56","v":2.06},{"$f":"'Connection Charges'!E56","v":3.11},{"$f":"D55+E55","v":5.17}]
[]
[null,null,"EQUIPMENT CHARGE"]
[null,null,"Meter size (in)","Meter Charge  - Developer Install Box & Yoke*            ","Meter Charge -                GRU Install Box & Yoke","GRU Installed Backflow Preventer"]
[null,null,"3/4 - in",{"$f":"'Connection Charges'!D60","v":530},{"$f":"'Connection Charges'!E60","v":872},{"$f":"'Connection Charges'!F60","v":408}]
[null,null,"1 - in",{"$f":"'Connection Charges'!D61","v":658},{"$f":"'Connection Charges'!E61","v":1140}]
[null,null,"1 1/2\"",null,{"$f":"'Connection Charges'!E62","v":2883}]
[null,null,"2\"",null,{"$f":"'Connection Charges'!E63","v":3080}]
[null,null,"3\"",null,{"$f":"'Connection Charges'!E64","v":17606}]
[null,null,"4\"",null,{"$f":"'Connection Charges'!E65","v":19569}]
[null,null,"6\"",null,{"$f":"'Connection Charges'!E67","v":25792}]
[null,null,"8\"",null,{"$f":"'Connection Charges'!E69","v":30397}]
[null,null,"*Existing meter box or developer installed meter box."]
[]
[null,null,"TEMPORARY SERVICE"]
[null,null,"Description",null,"Fee"]
[null,null,"Nonrefundable install & removal",null,{"$f":"'Connection Charges'!E75","v":127}]
[null,null,"Hydrant Meter Deposit",null,{"$f":"'Connection Charges'!E76","v":1548}]
[null,null,"Temporary Meter Deposit",null,{"$f":"E72","v":1548}]
[]
[]
[null,"WASTEWATER "]
[]
[null,null,"Consumption","Wastewater Collection System Connection Charge","Wastewater Treatment Plant Connection Charge","Total Wastewater Connection Charge"]
[null,null,"Single Family & Small Nonresidential                             ≤ 280 gallons per day (gpd)",{"$f":"'Connection Charges'!D82","v":961},{"$f":"'Connection Charges'!E82","v":3293},{"$f":"E79+D79","v":4254}]
[null,null,"Nonresidential                                                             ˃ 280 gpd ($/gpd) ",{"$f":"'Connection Charges'!D85","v":3.43},{"$f":"'Connection Charges'!E85","v":11.76},{"$f":"E80+D80","v":15.19}]
[]
[null,"DEVELOPER FEES"]
[]
[null,null,"PLAN REVIEW FEES"]
[null,null,"Water",{"$f":"'Connection Charges'!D90","v":980}]
[null,null,"Wastewater",{"$f":"'Connection Charges'!D91","v":1760}]
[]
[null,null,"INSPECTION FEES"]
[null,null,"Water",{"$f":"'Connection Charges'!D94","v":3.17},"per linear foot"]
[null,null,"Wastewater",{"$f":"'Connection Charges'!D95","v":7.81},"per linear foot"]
[]
[null,null,"TAPPING FEES"]
[null,null,"Tap size (inches)","Charge"]
[null,null,"1 1/2\"",{"$f":"'Connection Charges'!D99","v":1345}]
[null,null,"2\"",{"$f":"'Connection Charges'!D100","v":2038}]
[null,null,"4\"",{"$f":"'Connection Charges'!D101","v":4850}]
[null,null,"6\"",{"$f":"'Connection Charges'!D102","v":5024}]
[null,null,"8\"",{"$f":"'Connection Charges'!D103","v":6246}]
[null,null,"12\"",{"$f":"'Connection Charges'!D104","v":8580}]
[]
[null,"NON-RESIDENTIAL FLOW ESTIMATES"]
[]
[null,null,"Category",null,null,null,null,"Coefficient","*  Bldg SQFT  =   GPD"]
[null,null,"Auto: sales, repair, rental, tire, storage, body shops",null,null,null,null,3.0766083811176924E-2]
[null,null,"Car wash",null,null,null,null,1.0615332337770451]
[null,null,"Churches",null,null,null,null,3.326168153081846E-2]
[null,null,"Department Store, Box Store",null,null,null,null,1.0911272384037392E-2]
[null,null,"Drive-in restaurants",null,null,null,null,0.36916606313889844]
[null,null,"Dry cleaning,  laundry mats",null,null,null,null,0.65427027428344198]
[null,null,"Financial Institutions",null,null,null,null,1.8440851898706631E-2]
[null,null,"Florists, greenhouses",null,null,null,null,4.1614963227505221E-2]
[null,null,"Golf courses, driving ranges",null,null,null,null,0.18530352001843775]
[null,null,"Gym, Workout Facility",null,null,null,null,4.1717440714168351E-2]
[null,null,"Hotel",null,null,null,null,0.13492744540979371]
[null,null,"Industrial, manufacturing",null,null,null,null,2.0602493074792245E-2]
[null,null,"Lumberyards, sawmills, planning mills",null,null,null,null,1.0339794015083935E-2]
[null,null,"Medical",null,null,null,null,6.0206219348241927E-2]
[null,null,"Mixed Use:  Store & Office, Store & Residential",null,null,null,null,3.4366904840127818E-2]
[null,null,"Mortuaries, cemeteries, crematoriums",null,null,null,null,7.3072943038508864E-2]
[null,null,"Nightclubs, cocktail lounges, bars",null,null,null,null,0.15823727399994045]
[null,null,"Office building",null,null,null,null,3.5478477905406286E-2]
[null,null,"Open storage, building supplies, junk yards, auto wrecking, fuel storage",null,null,null,null,5.5391329223623914E-2]
[null,null,"Pharmacy",null,null,null,null,1.757988482311779E-2]
[null,null,"Private schools, colleges and daycare facilities",null,null,null,null,7.4946551947176754E-2]
[null,null,"Repair service shops (non-automotive)",null,null,null,null,2.5454848575945811E-2]
[null,null,"Restaurants (other than drive-in)",null,null,null,null,0.33430892667911388]
[null,null,"Retirement homes, orphanages, group homes",null,null,null,null,0.10716814586535132]
[null,null,"Service stations",null,null,null,null,7.2371455819145059E-2]
[null,null,"Storage Units",null,null,null,null,1.7938275910055592E-3]
[null,null,"Store, community shopping center (other than supermarkets and department stores)",null,null,null,null,3.4902513496910245E-2]
[null,null,"Supermarkets",null,null,null,null,5.7305595081983719E-2]
[null,null,"Theaters, Bowling alleys, skating rinks, pool halls, enclosed arenas, auditoriums",null,null,null,null,4.6487358202944667E-2]
[null,null,"Union halls, lodges, clubs, club houses ",null,null,null,null,4.4764727016631062E-2]
[null,null,"Utility - other than GRU",null,null,null,null,1.4058744872950776E-2]
[null,null,"Warehouse, distribution centers, truck terminals",null,null,null,null,2.1186440677966101E-2]
[null,null,"Wholesale & manufacturing outlets, produce houses",null,null,null,null,1.5211701064757036E-2]

{"sheet":"DropDownDef","index":3,"n_rows":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
["Y","3/4 - in","City","Single Family","Water","X","Meter only","Auto: sales, repair, rental, tire, storage, body shops","1\"","Water, Wastewater"]
["N","1 - in","County","Multi Family","Water, Wastewater",null,"Meter, box, & yoke","Car wash","2\"","Water"]
[null,"1 1/2\"",null,"Non-residential","Water, Irrigation, Wastewater",null,null,"Churches","4\"","Wastewater"]
[null,"2\"",null,null,"Wastewater",null,null,"Department Store, Box Store","6\""]
[null,"3\"",null,null,"Irrigation ",null,null,"Drive-in restaurants","8\""]
[null,"4\"",null,null,"Irrigation, Wastewater",null,null,"Dry cleaning,  laundry mats","12\""]
[null,"6\"",null,null,"Hydrant meter",null,null,"Financial Institutions"]
[null,"8\"",null,null,"Temporary meter",null,null,"Florists, greenhouses"]
[null,null,null,null,null,null,null,"Golf courses, driving ranges"]
[null,null,null,null,null,null,null,"Gym, Workout Facility"]
[null,null,null,null,null,null,null,"Hotel"]
[null,null,null,null,null,null,null,"Industrial, manufacturing"]
[null,null,null,null,null,null,null,"Libraries and Museums"]
[null,null,null,null,null,null,null,"Lumberyards, sawmills, planning mills"]
[null,null,null,null,null,null,null,"Medical"]
[null,null,null,null,null,null,null,"Mixed Use:  Store & Office, Store & Residential"]
[null,null,null,null,null,null,null,"Mortuaries, cemeteries, crematoriums"]
[null,null,null,null,null,null,null,"Nightclubs, cocktail lounges, bars"]
[null,null,null,null,null,null,null,"Office building"]
[null,null,null,null,null,null,null,"Open storage, building supplies, junk yards, auto wrecking, fuel storage"]
[null,null,null,null,null,null,null,"Pharmacy"]
[null,null,null,null,null,null,null,"Private schools, colleges and daycare facilities"]
[null,null,null,null,null,null,null,"Repair service shops (non-automotive)"]
[null,null,null,null,null,null,null,"Restaurants (other than drive-in)"]
[null,null,null,null,null,null,null,"Retirement homes, orphanages, group homes"]
[null,null,null,null,null,null,null,"Service stations"]
[null,null,null,null,null,null,null,"Storage Units"]
[null,null,null,null,null,null,null,"Store, community shopping center (other than supermarkets and department stores)"]
[null,null,null,null,null,null,null,"Supermarkets"]
[null,null,null,null,null,null,null,"Theaters, Bowling alleys, skating rinks, pool halls, enclosed arenas, auditoriums"]
[null,null,null,null,null,null,null,"Union halls, lodges, clubs, club houses "]
[null,null,null,null,null,null,null,"Utility - other than GRU"]
[null,null,null,null,null,null,null,"Warehouse, distribution centers, truck terminals"]
[null,null,null,null,null,null,null,"Wholesale & manufacturing outlets, produce houses"]